Release 10.1A: OpenEdge Data Management:
SQL Reference

SYSTABLES

Contains one row for each table in the database.

Table 5 provides details of the SYSTABLES table.

Table 5: SYSTABLES core system table 

Column name	Column data type	Column size
creator	VARCHAR	32
has_ccnstrs	VARCHAR	1
has_fcnstrs	VARCHAR	1
has_pcnstrs	VARCHAR	1
has_ucnstrs	VARCHAR	1
id	INTEGER	4
owner	VARCHAR	32
rssid	INTEGER	4
segid	INTEGER	4
tbl	VARCHAR	32
tbl_status	VARCHAR	1
tbltype	VARCHAR	1